package com.example.todolist.mapper;

import org.apache.ibatis.annotations.*;

@Mapper
public interface VerificationMapper {
    @Insert("Insert into verification(name,number)VALUES(#{name},#{number})")
    void Insert(String name,Integer number);

    @Select("select count(*) from verification where name=#{name}")
    Integer find(String name);

    @Select("select number from verification where name=#{name}")
    Integer getTheNumber(String name);

    @Delete("delete from verification where name=#{name}")
    void deleteTheNumber(String name);

    @Update("update verification set number=#{number} where name=#{name}")
    void update(String name,Integer number);

}
